
		**********************************************************
		** File: cleaning_Alesina_et_al.do 						**
		** Paper: Human Trafficking Indicators: A New Dataset	**
		** Author: Richard Frank								**
		** Date: July 11, 2021									**
		** Task: cleaning Alesina et al. (2003)					**
		**********************************************************

		clear
		version 16.1
		set seed 1234
		set more off
		clear matrix
		clear mata

		cd "~"
		
		** data from: https://www.anderson.ucla.edu/faculty_pages/romain.wacziarg/papersum.html
		
		import excel "Alesina et al 2003.xlsx", sheet("ELF") firstrow case(lower) clear
		rename country Country
		run "cow.do"
		sort ccode
		drop if ccode==0
		order Country ccode
		rename Country country
		drop if country=="Serbia and Montenegro"
		drop if country=="Hong Kong"
		drop if country=="Macau"		
		label var  ethnic "Ethnic fractionalisation (Alesina)"
		label var language "Language fractionalisation (Alesina)"
		label var religion "Religious fractionalization (Alesina)"
		
		save "Alesina et al 2003.dta", replace
